www.gusucode.com > VC++ 客户管理系统(SQL Serve)-源码程序 > VC++ 客户管理系统(SQL Serve)-源码程序/code/Program/qkh.cpp
// qkh.cpp : implementation file // #include "stdafx.h" #include "khmanager.h" #include "qkh.h" #include "ado.h" #include "xkh.h" #ifdef _DEBUG #define new DEBUG_NEW #undef THIS_FILE static char THIS_FILE[] = __FILE__; #endif ///////////////////////////////////////////////////////////////////////////// // qkh dialog qkh::qkh(CWnd* pParent /*=NULL*/) : CDialog(qkh::IDD, pParent) { //{{AFX_DATA_INIT(qkh) // NOTE: the ClassWizard will add member initialization here //}}AFX_DATA_INIT } void qkh::DoDataExchange(CDataExchange* pDX) { CDialog::DoDataExchange(pDX); //{{AFX_DATA_MAP(qkh) DDX_Control(pDX, IDC_LIST1, m_list); DDX_Control(pDX, IDC_EDIT1, m_edit); DDX_Control(pDX, IDC_COMBO2, m_com2); DDX_Control(pDX, IDC_COMBO1, m_com1); //}}AFX_DATA_MAP } BEGIN_MESSAGE_MAP(qkh, CDialog) //{{AFX_MSG_MAP(qkh) ON_BN_CLICKED(IDC_BUTTON2, OnButton2) ON_BN_CLICKED(IDC_BUTTON1, OnButton1) ON_CBN_SELCHANGE(IDC_COMBO1, OnSelchangeCombo1) ON_NOTIFY(NM_DBLCLK, IDC_LIST1, OnDblclkList1) //}}AFX_MSG_MAP END_MESSAGE_MAP() ///////////////////////////////////////////////////////////////////////////// // qkh message handlers BOOL qkh::OnInitDialog() { CDialog::OnInitDialog(); this->m_com1.AddString("客户编号"); this->m_com1.AddString("客户名称"); this->m_com1.AddString("企业性质"); this->m_com1.AddString("企业类型"); this->m_com1.AddString("企业资信"); this->m_com1.AddString("企业地址"); this->m_com1.AddString("所属省份"); this->m_com1.AddString("所属城市"); this->m_com1.AddString("公司邮编"); this->m_com1.AddString("法人代表"); this->m_com1.AddString("开户银行"); this->m_com1.AddString("银行账号"); this->m_com1.AddString("纳税号"); this->m_com1.AddString("客户IC卡号"); this->m_com1.AddString("公司网址"); this->m_com1.AddString("公司电话"); this->m_com1.AddString("公司传真"); this->m_com1.AddString("主要联系人"); this->m_com1.AddString("联系人电话"); this->m_com1.AddString("客户级别"); this->m_com1.AddString("备注信息"); this->m_com2.AddString("like"); this->m_com2.AddString("="); // this->m_com2.AddString(">"); // this->m_com2.AddString("<"); // this->m_com2.AddString("<>"); // this->m_com2.AddString(">="); // this->m_com2.AddString("<="); m_list.ModifyStyle(0L,LVS_SHOWSELALWAYS); m_list.SetExtendedStyle(LVS_EX_GRIDLINES| LVS_EX_FULLROWSELECT| LVS_EX_HEADERDRAGDROP| LVS_EX_ONECLICKACTIVATE); m_list.InsertColumn(0,"客户编号"); m_list.InsertColumn(1,"客户名称"); m_list.InsertColumn(2,"企业性质"); m_list.InsertColumn(3,"企业类型"); m_list.InsertColumn(4,"企业资信"); m_list.InsertColumn(5,"企业地址"); m_list.InsertColumn(6,"所属省份"); m_list.InsertColumn(7,"所属城市"); m_list.InsertColumn(8,"公司邮编"); m_list.InsertColumn(9,"法人代表"); m_list.InsertColumn(10,"开户银行"); m_list.InsertColumn(11,"银行账号"); m_list.InsertColumn(12,"纳税号"); m_list.InsertColumn(13,"客户IC卡号"); m_list.InsertColumn(14,"公司网址"); m_list.InsertColumn(15,"公司电话"); m_list.InsertColumn(16,"公司传真"); m_list.InsertColumn(17,"主要联系人"); m_list.InsertColumn(18,"联系人电话"); m_list.InsertColumn(19,"客户级别"); m_list.InsertColumn(20,"备注信息"); m_list.SetColumnWidth(0,100); m_list.SetColumnWidth(1,100); m_list.SetColumnWidth(2,100); m_list.SetColumnWidth(3,100); m_list.SetColumnWidth(4,100); m_list.SetColumnWidth(5,100); m_list.SetColumnWidth(6,100); m_list.SetColumnWidth(7,100); m_list.SetColumnWidth(8,100); m_list.SetColumnWidth(9,100); m_list.SetColumnWidth(10,100); m_list.SetColumnWidth(11,100); m_list.SetColumnWidth(12,100); m_list.SetColumnWidth(13,100); m_list.SetColumnWidth(14,100); m_list.SetColumnWidth(15,100); m_list.SetColumnWidth(16,100); m_list.SetColumnWidth(17,100); m_list.SetColumnWidth(18,100); m_list.SetColumnWidth(19,100); m_list.SetColumnWidth(20,100); m_list.EnableAutomation(); this->loadlist(); return TRUE; // return TRUE unless you set the focus to a control // EXCEPTION: OCX Property Pages should return FALSE } void qkh::loadlist() { ado rst; rst.Open("select * from tb_khxx",adCmdText); int recordcount=rst.GetRecordCount(); int ii; for(ii=1;ii<=recordcount;ii++) { m_list.InsertItem(ii-1,""); m_list.SetItemText(ii-1,0,rst.GetFieldValue("khxx_id")); m_list.SetItemText(ii-1,1,rst.GetFieldValue("khxx_mc")); m_list.SetItemText(ii-1,2,rst.GetFieldValue("khxx_qyxz")); m_list.SetItemText(ii-1,3,rst.GetFieldValue("khxx_qylx")); m_list.SetItemText(ii-1,4,rst.GetFieldValue("khxx_qyzx")); m_list.SetItemText(ii-1,5,rst.GetFieldValue("khxx_qydz")); m_list.SetItemText(ii-1,6,rst.GetFieldValue("khxx_szsf")); m_list.SetItemText(ii-1,7,rst.GetFieldValue("khxx_szcs")); m_list.SetItemText(ii-1,8,rst.GetFieldValue("khxx_gsyb")); m_list.SetItemText(ii-1,9,rst.GetFieldValue("khxx_frdb")); m_list.SetItemText(ii-1,10,rst.GetFieldValue("khxx_khyh")); m_list.SetItemText(ii-1,11,rst.GetFieldValue("khxx_yhzh")); m_list.SetItemText(ii-1,12,rst.GetFieldValue("khxx_nsh")); m_list.SetItemText(ii-1,13,rst.GetFieldValue("khxx_ICcard")); m_list.SetItemText(ii-1,14,rst.GetFieldValue("khxx_gswz")); m_list.SetItemText(ii-1,15,rst.GetFieldValue("khxx_gsdh")); m_list.SetItemText(ii-1,16,rst.GetFieldValue("khxx_gscz")); m_list.SetItemText(ii-1,17,rst.GetFieldValue("khxx_lxr")); m_list.SetItemText(ii-1,18,rst.GetFieldValue("khxx_lxrdh")); m_list.SetItemText(ii-1,19,rst.GetFieldValue("khxx_khjb")); m_list.SetItemText(ii-1,20,rst.GetFieldValue("khxx_bz")); rst.Move(ii); } rst.close(); } void qkh::OnButton2() { this->EndDialog(true); } void qkh::OnButton1() { m_list.DeleteAllItems(); ado rst; CString sql,edit1,com1,com2; this->m_edit.GetWindowText(edit1); this->m_com2.GetWindowText(com2); this->m_com1.GetWindowText(com1); if(edit1.IsEmpty()) {MessageBox("请输入","提示"); return; } if(com2.IsEmpty()) {MessageBox("请输入","提示"); return; } if(com1.IsEmpty()) {MessageBox("请输入","提示"); return; } if(com2 == "=") sql.Format("select * from tb_khxx where %s %s '%s'",ssel,com2,edit1); else sql.Format("select * from tb_khxx where %s %s '%s%s%s'",ssel,com2,"%",edit1,"%"); rst.Open(sql,adCmdText); int recordcount=rst.GetRecordCount(); int ii; for(ii=1;ii<=recordcount;ii++) { m_list.InsertItem(ii-1,""); m_list.SetItemText(ii-1,0,rst.GetFieldValue("khxx_id")); m_list.SetItemText(ii-1,1,rst.GetFieldValue("khxx_mc")); m_list.SetItemText(ii-1,2,rst.GetFieldValue("khxx_qyxz")); m_list.SetItemText(ii-1,3,rst.GetFieldValue("khxx_qylx")); m_list.SetItemText(ii-1,4,rst.GetFieldValue("khxx_qyzx")); m_list.SetItemText(ii-1,5,rst.GetFieldValue("khxx_qydz")); m_list.SetItemText(ii-1,6,rst.GetFieldValue("khxx_szsf")); m_list.SetItemText(ii-1,7,rst.GetFieldValue("khxx_szcs")); m_list.SetItemText(ii-1,8,rst.GetFieldValue("khxx_gsyb")); m_list.SetItemText(ii-1,9,rst.GetFieldValue("khxx_frdb")); m_list.SetItemText(ii-1,10,rst.GetFieldValue("khxx_khyh")); m_list.SetItemText(ii-1,11,rst.GetFieldValue("khxx_yhzh")); m_list.SetItemText(ii-1,12,rst.GetFieldValue("khxx_nsh")); m_list.SetItemText(ii-1,13,rst.GetFieldValue("khxx_ICcard")); m_list.SetItemText(ii-1,14,rst.GetFieldValue("khxx_gswz")); m_list.SetItemText(ii-1,15,rst.GetFieldValue("khxx_gsdh")); m_list.SetItemText(ii-1,16,rst.GetFieldValue("khxx_gscz")); m_list.SetItemText(ii-1,17,rst.GetFieldValue("khxx_lxr")); m_list.SetItemText(ii-1,18,rst.GetFieldValue("khxx_lxrdh")); m_list.SetItemText(ii-1,19,rst.GetFieldValue("khxx_khjb")); m_list.SetItemText(ii-1,20,rst.GetFieldValue("khxx_bz")); rst.Move(ii); } rst.close(); } void qkh::OnSelchangeCombo1() { switch(m_com1.GetCurSel()) { case 0: ssel="khxx_id"; break; case 1: ssel="khxx_mc"; break; case 2: ssel="khxx_qyxz"; break; case 3: ssel="khxx_qylx"; break; case 4: ssel="khxx_qyzx"; break; case 5: ssel="khxx_qydz"; break; case 6: ssel="khxx_szsf"; break; case 7: ssel="khxx_szcs"; break; case 8: ssel="khxx_gsyb"; break; case 9: ssel="khxx_frdb"; break; case 10: ssel="khxx_khyh"; break; case 11: ssel="khxx_yhzh"; break; case 12: ssel="khxx_nsh"; break; case 13: ssel="khxx_ICcard"; break; case 14: ssel="khxx_gswz"; break; case 15: ssel="khxx_gsdh"; break; case 16: ssel="khxx_gscz"; break; case 17: ssel="khxx_lxr"; break; case 18: ssel="khxx_lxrdh"; break; case 19: ssel="khxx_khjb"; break; case 20: ssel="khxx_bz"; break; } } void qkh::OnDblclkList1(NMHDR* pNMHDR, LRESULT* pResult) { int i=m_list.GetHotItem(); if(i<0) {return;} xkh k; ado rst; CString ss; ss.Format("select * from tb_khxx where khxx_id='%s'",m_list.GetItemText(i,0)); rst.rstOpen(ss); k.edit1=rst.GetFieldValue("khxx_id"); k.edit8=rst.GetFieldValue("khxx_mc"); k.com1=rst.GetFieldValue("khxx_qyxz"); k.com2=rst.GetFieldValue("khxx_qylx"); k.com5=rst.GetFieldValue("khxx_qyzx"); k.edit2=rst.GetFieldValue("khxx_qydz"); k.com3=rst.GetFieldValue("khxx_szsf"); k.edit9=rst.GetFieldValue("khxx_szcs"); k.edit3=rst.GetFieldValue("khxx_gsyb"); k.edit10=rst.GetFieldValue("khxx_frdb"); k.edit12=rst.GetFieldValue("khxx_khyh"); k.edit4=rst.GetFieldValue("khxx_yhzh"); k.edit11=rst.GetFieldValue("khxx_nsh"); k.edit13=rst.GetFieldValue("khxx_ICcard"); k.edit5=rst.GetFieldValue("khxx_gswz"); k.edit14=rst.GetFieldValue("khxx_gsdh"); k.edit6=rst.GetFieldValue("khxx_gscz"); k.edit15=rst.GetFieldValue("khxx_lxr"); k.edit7=rst.GetFieldValue("khxx_lxrdh"); k.com4=rst.GetFieldValue("khxx_khjb"); k.edit16=rst.GetFieldValue("khxx_bz"); rst.close(); k.DoModal(); *pResult = 0; }